const mysql = require('mysql2')

const sql = {
  createConnection() {
    return mysql.createPool({
      connectionLimit: 100,
      host: '127.0.0.1',//数据库地址
      // host: '111.31.77.8',
      port: '3306',
      user: 'root',//用户名，没有可不填
      password: '123456',//密码，没有可不填
      database: 'kantan',//数据库名称
      multipleStatements: true
    })
  }
}
module.exports = sql
